/*
var selectSQL='select * from admin limit 0,10';
var deleteSQL='delete from admin';
var updataSQL='update admin set name="conan" where username="conan"';


var connection=mysql.createConnection({
  'host':'localhost',
  'user':'root',
  'password':'123456',
  'port':'3306',
  'database':'CataSystem'
});
//插入注册信息
function insertSQL(x,y,z) {
  var insertSQL='insert into admin(username,userpas,usertel) values("'+x+'","'+y+'","'+z+'")';
  return insertSQL;
}
function operateSQL(req) {
  connection.query(req,function (err,res) {
    if(err){
      console.log(err);
    }
    console.log("success to delete");
    console.log(res);
  });
}
//operateSQL(deleteSQL);
//operateSQL(insertSQL('admin2','123456','13542741886'));
//operateSQL(deleteSQL);

exports.insertSQL=insertSQL;
exports.operateSQL=operateSQL;*/
var UserSQL={
  user:{
    add:'insert into admin(username,userpas,usertel) values  (?,?,?);',
    checklogin:'SELECT userpas FROM admin WHERE username = ?;',
  },
  datames:{
    selectbasefood:'SELECT * FROM basefood'
  }
}
module.exports=UserSQL;
